﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'usp_UPDMS_COM_LABEL_Get_Label_Nm_By_Seq')
	BEGIN
		DROP Procedure usp_UPDMS_COM_LABEL_Get_Label_Nm_By_Seq
	END
GO

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
/******************************************************************************
**	Name : usp_UPDMS_COM_LABEL_Get_Label_Nm_By_Seq
**	Desc : 프로그램별 라벨정보 조회
**	Test Exec Query : Exec usp_UPDMS_COM_LABEL_Get_Label_Nm_By_Seq 16, 'ko'
**	Called by : All
**	Program ID : All
**	Auth : 송시명
**	Date : 2013-05-24
*******************************************************************************
**	Change History
*******************************************************************************
**	Date:		Author:		Description:
**	--------	--------	---------------------------------------
**						
*******************************************************************************/
CREATE PROC [dbo].[usp_UPDMS_COM_LABEL_Get_Label_Nm_By_Seq]
@li_seq int,
@ls_lang_set nvarchar(2)
AS
SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

SELECT CASE @ls_lang_set
            WHEN 'ko' THEN Label_Ko
            WHEN 'en' THEN Label_En
            WHEN 'ch' THEN Label_Ch
            ELSE Label_Ko
       END Label_Nm
  FROM UPDMS_COM_LABEL WITH(NOLOCK)
 WHERE Seq = @li_seq

GO